| ยท | You must be familiar with SQL syntax to use this action.
|
|
|
|
|
| Connection String
|
| A string with attribute/value pairs for information required to log on to a database and point to a specific database. Click the browse button to open the Microsoft Data Link Properties dialog box. You can press F1 to access Help about this dialog box.
|
|
|
| SQL Query
|
| Enter the query string in SQL syntax.
|
|
|
| Assign Field Names to Variable
|
| Stores the field names separated by commas in a specified variable.
|
|
|
| Assign Field Values to Variable
|
| Stores the field values separated by commas in a specified variable.
|
|
|
| With Memo Fields
|
| Specifies that the query should include memo fields.
|
|
|
| Store Memos as "Comma Text"
|
| Indicates that the memo fields should be stored as comma delimited text.
|
|
|
| Variable
|
| Allows you to add a variable to the action or triggering event that you selected. You must place the cursor in a edit box in the settings dialog window of the action or event and then click the {V} button.
|
|
|
|
|
| Test SQL
|
| Allows you to test the SQL syntax of your query.
|
|
|
 Related Topics
|
| File Loop
|
| Text Loop
|
| Simple Loop
|
| End Loop
|
| Break
|
| Continue
|
| If Then
|
| Else
|
| End If
|
|
|
|
|
|
|
|
|